﻿

CREATE VIEW [dbo].[fares_viewDetaliuPlata]
AS
SELECT     dbo.DocumentePlataDetaliu.IDDocPlataDetaliu, dbo.Documente.NrDoc, dbo.Documente.DataDoc, dbo.DocumentePlataDetaliu.IDDocumentPlata, 
                      dbo.Documente.IDDocument
FROM         dbo.DocumentePlataDetaliu LEFT OUTER JOIN
                      dbo.Documente ON dbo.DocumentePlataDetaliu.IDDocument = dbo.Documente.IDDocument